package com.atguigu.gmall.publisher.mapper;

import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;

/**
 * @author Felix
 * @date 2022/12/20
 * 交易域统计Mapper接口
 */
public interface TradeStatsMapper {
    //获取某一天总交易额
    @Select("select sum(order_amount) order_amount from dws_trade_province_order_window where toYYYYMMDD(stt)=#{date}")
    BigDecimal selectGMV(Integer date);
}